SUPPORT / SAMPLES & SAS NOTES
Problem Note 48127: Running a Base SAS® procedure on DB2 in a z/OS operating environment might result in an error
 |  |  |  |
Running a Base SAS procedure under z/OS against a DB2 table might result in the following error:
This issue might occur with the following procedures when the system option SQLGENERATION is set to DBMS or DBMS='DB2':
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
ERROR: Requested function is not supported.
- MEANS
- RANK
- REPORT
- SUMMARY
- TABULATE
In-database processing of the procedures for SAS/ACCESS® Interface to DB2 under z/OS is not supported until the second maintenance release of SAS 9.3 (TS1M2). The table is retrieved from DB2 and the processing is done in SAS as was done previously.
The only workaround is to set the system option SQLGENERATION=NONE.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M0 | 9.3 TS1M2 |